package com.mapper;

import com.pojo.Worker;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
* @author admin
* @description 针对表【tb_worker】的数据库操作Mapper
* @createDate 2024-11-16 13:51:30
* @Entity com.pojo.Worker
*/
public interface WorkerMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Worker record);

    int insertSelective(Worker record);

    Worker selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Worker record);

    int updateByPrimaryKey(Worker record);

    @Select("select * from tb_worker where id =#{id}")
    Worker SelectWorkey(int id);
    @Insert("insert into tb_worker(name,age,sex,worker_id) values (#{name},#{age},#{sex},#{workerId})")
    int insertWorkey(Worker worker);
    @Update("update tb_worker set name=#{name} ,age =#{age} ,sex= #{sex},worker_id=#{workerId} where id=#{id}")
    int updateWorkey(Worker worker);
    @Delete("delete from tb_worker where id=#{id}")
    int deleteWorkey(int id);
}
